home *** CD-ROM | disk | FTP | other *** search
/ Power Programmierung / Power-Programmierung (Tewi)(1994).iso / magazine / dbms_mag / 9103 / sql6.mar < prev    next >
Text File  |  1991-01-22  |  227b  |  2 lines
  1.  
  2. CREATE VIEW city_chg(city,total_last_yr,total_this_yr) AS  SELECT y90.city, y90.total_sales, y91.total_sales    FROM city_hist y90, city_hist y91   WHERE y90.city = y91.city     AND y90.yr = 1990     AND y91.yr = 1991;